
SELECT
CONVERT(TIME,GETDATE()) AS HourMinuteSecond,
CONVERT(DATE,GETDATE(),101) AS DateOnly
GO

select * from p_noli_advance where validoal>getdate() and convert(time, validoal)<>'23:59:59.000'